SQLBase C/API CONNECT SERVER, UNLOAD, DEINSTALL, DELETE,CREATE,CONNECT CURSOR, LOAD & DISCONNECT [16 bit version also: EXIT SQLBase Engine & WINDOWS]

SQLBase C/API CONNECT SERVER, UNLOAD, DEINSTALL, DELETE,CREATE,CONNECT CURSOR, LOAD & DISCONNECT [16 bit version also: EXIT SQLBase Engine & WINDOWS]
MAINTASK:

1. Unload .DBS, or

2. Create .DBS & LOAD, or

3. LOAD into existing .DBS, or

4. UNLOAD, DROP .DBS, CREATE .DBS, LOAD = Reorganize

REMARKS:

Source-code is in .APT format
SBCAPI16.APT, Written i SQLWindows 5.03 for Windows 3.x, (will do on Windows 95 too)
SBCAPI32.APT, Written in CTD.100 (no PTF <s>)
Only valid for SQLBase >= 6.x
Use of SQLBase C/API for handling Server & .DBS
Only use of .SQL file format.
Use the VT.APL for writing (.LOG) activity report and, if successful termination, .OK3 file
Use .OK3 file for DOS handling. If exist .OK3 then do ....
Write unload trace file [.OK1] using LOG option in UNLOAD-statement
Write load trace file [.OK2] using LOG option in LOAD-statement
.OK? and LOG file has the same name as the .SQL files
Will generate SBCAPInn.INI in working directory.
Checkbox for customizing load / unload & print the .LOG/OK? file
In the .INI file, set nSalPause=n where n = 100000 for every minute you want pause between unload and Load in a reorganize situation. Can be needed when unload/load of a large .DBS, while server does housekeeping

16 bit VERSION ONLY:

C/API Unload sqlunl() & Load sqlldp() will only run correct WHEN the

correct version of SQLAPIW.DLL gets loaded !!! Use Winapps.exe or Sqledit.exe to figure this out.

Also use of VT for the cMETER. (active on kill windows)
Optionally safe shutdown of Sqlbase Engine and Windows by using calls to USER.EXE and a timer

32 bit VERSION ONLY:

Servername must ALWAYS be typed in. LOCAL32 is assumed by program

Please change this to whatever you have set up in your SQL.INI file

BATCH PROCESSING:

- Compiled SBCAPI.EXE can be run from command line like this using

8 parameters:

C:\WINDOWS C:\yourdir\SBCAPInn.EXE A B C D E F G H

where the A can be 1, 2, 3 or 4

A = 1 = Unload .DBS

2 = Create .DBS & LOAD

3 = LOAD into existing .DBS

4 = Reorganize

B can be 0 or 1, 0 = stay in windows, 1 = shut down windows.

C = YOURDB

D = USER

E = PASSWORD

F = C:\DIR\YOURDB.SQL

G = SERVERNAME

H = SERVERPASSWORD

16 bit only: The SERVERNAME & SERVERPASSWORD can be omitted. Omit it if you run local .DBS [Batch-processing NOT testet in W'95]

32 bit only, or 16 bit aginst 32 bit backend: The SERVERNAME must be filled

DATAFIELDS:

SERVERNAME:

SERVERPASSWORD:

DATABASENAME:

USERNAME:

PASSWORD:

SQLFILENAME:

16 bit backend: Omit the SERVERNAME & SERVERPASSWORD as a start. = the job will run local.

Also: the dbname should be typed in without the .DBS extension

and the .SQL-filename must be FULLY qualified.

16 bit & 16 bit backend: If servername is omitted, .LOG,.OK1, .OK2 & .OK3 files will be created in dir of .SQL file

32 bit: Servername filled, files will be created in the C: directory, the

.OK1 & .OK2 file in C: dir of the server - whereever your SERVER is...

USE SQL or C/API

Both methods for load & unload are available

Which do you think is the fastets method ?
ACTIVITY REPORT

Use of NOTEPAD.EXE to show .OK1, .OK2 & .LOG results
Error will be found in these files.
Error numbers in .LOG file you'll have to convert using ERROR.SQL
Optionally print activity-report .LOG + .OK? file using a checkbutton.

SERVER:

If your .SQL is located on the server it must be specified by volume/directory instead by mapped devices.

BACKUP .DBS:

PLEASE TAKE A COPY OF YOUR .DBS UNTIL YOU ARE FAMILIAR WITH THE PROGRAM.

CAUTION - CAUTION - CAUTION and even more CAUTION:

The program use NO RECOVERY for loading. I cannot stress how important a

good backup stategy is when using the SqlNoRecovery variable.

Backup, backup, backup ... and then backup some more ...
UNINSTALL

All components are named SBCAPI*.*, simply remove them.

LIFETIME STORY:

ver 1.00 - The trial run.

ver 1.01 - Small cosmetic fixes, correct calculation off runtime.

ver 1.02 - Options for customizing unload/load

ver 1.03 - NoRecovery removed from unload (no benefit).

Workaround for show/print big .OK? files, due to limitations

off NOTEPAD.EXE, Show/print .OK? changed to an option.

ver 1.04 - CTD version, Dialog-box to pickup .SQL filenames,

New filenames: SBCAPI16.APT & SBCAPI32.APT, Documentation available from formwindow

Have fun, comments are welcome ;--))

Uploaded by:

Carsten Barner Nielsen

ISS Data A/S, Copenhagen, Denmark

Email: 101463.2173@compuserve.com